Exact Financials (v3)

CC_BAL

CC_BAL(acc_nr,cc,co,FY,period,balance_type,value,calc)

Using this function you can include the balance of a cost center balance sheet accounts in the worksheet.

Example

CC_BAL(3000,WAREHOUSE,100,2002,12,1,1,1)

As a result of the above function, the debit balance of the cost center 'WAREHOUSE' is included in the financial year 2002 and period 12, based on the amounts entered in general ledger account 3000.

Note that a range of cost centers can be entered by separating the cost centers with a colon (:).

Example

CC_BAL(3000,ADMI:DIR,100,2004,6,1,1)

Returns the debit balance of all cost centers between 'ADMI' and 'DIR' in financial year 2004, period 6, on g/l account '3000'.

Excel Add-In contents | Alphabetical overview parameters